# coding =utf-8
import pandas as pd
import numpy as num

csv1=pd.read_csv('G:/学习教程/人工智能/Python就业班/基础班-就业班课件资料 -1-4位基础班  5-14就业班/12-人工智能阶段-数据分析/数据分析资料/day06/code/911.csv')
data=pd.DataFrame(csv1)
# data.set_index(data['lat'],inplace=True)
# print(type(data))
# print(data.index)
data2=data.groupby(by=data['addr'])
print(data2.get_group('RAMP S TROOPER RD TO RT422 EB & RT422 EB'))
print(data2['lng','lat','e'].agg(num.sum))

#
# print(data.head(2))
# dataGroup=data.groupby(by='title').agg(num.mean)
# print('&'*100)
# print(dataGroup)